<?php

include 'confidential_settings_heliohost.php';
// This include contains 5 variables:
//  - db_name: database name
//  - table_name_x: table name
//  - username: username
//  - password: password
//  - localhost: host name

//$table_name_here = $table_name_gsc;
//$table_name_here = $table_name_gas;
//$table_name_here = $table_name_wat;
//$table_name_here = $table_name_gsc_ns;
//$table_name_here = $table_name_gas_ns;
$table_name_here = $table_name_wat_ns;

$dbh=mysql_connect ($localhost, $username, $password) or die('Cannot connect to the database because: ' . mysql_error());
mysql_select_db ($db_name) or die(mysql_error()); 


$table_name_here = $table_name_gsc_ns;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_wat_ns;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_gas_ns;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_gsc;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_wat;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_gas;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

$table_name_here = $table_name_day;
$sql = "CREATE TABLE $table_name_here
(
val varchar(10),
date_entered timestamp DEFAULT CURRENT_TIMESTAMP
)";
// Execute query
mysql_query($sql);

mysql_close($dbh);
